package com.wie.staffhubpro.mapper;

import com.wie.staffhubpro.domain.entity.CalculateIndicator;
import com.wie.staffhubpro.domain.entity.ComprehensiveIndicator;
import com.wie.staffhubpro.domain.entity.SingleIndicatorEmp;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author WiedersehenM
* @description 针对表【single_indicator_emp】的数据库操作Mapper
* @createDate 2025-07-02 17:05:48
* @Entity com.wie.staffhubpro.domain.entity.SingleIndicatorEmp
*/
@Mapper
public interface SingleIndicatorEmpMapper extends BaseMapper<SingleIndicatorEmp> {

    @Select("select si.id, sie.emp_id, sie.ind_id, si.score, si.create_time " +
            "from single_indicator si, single_indicator_emp sie " +
            "where si.id = sie.per_id and si.create_time > CONCAT(YEAR(NOW()), '-01-01 00:00:00') ")
    List<ComprehensiveIndicator> selectComprehensive(CalculateIndicator calculateIndicator);
}




